﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Zor_IDAL;
using Zor_Modes;

namespace Zor_DAL
{
    public class RentingInfo_DAL
    {
        /// <summary>
        /// 获取用户租房信息
        /// </summary>
        /// <param name="name">租户名称</param>
        /// <param name="number">租户身份证号</param>
        /// <returns></returns>
        public static List<RentingInfo> GetRentingInfoList(string name, string number)
        {
            List<RentingInfo> lst = new List<RentingInfo>();
            var sql = "select * from V_GetTaxRecord where 1=1 ";
            sql += " and Tenant_Name= '" + name + "' and Tenant_IDNumber= '" + number + "' ";
            lst = DapperQuery<RentingInfo>.DoQueryList("1", sql, null);
            return lst;
        }

    }
}
